Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
First of all, let us take a look at what Excel provides math and trigonometric functions. The author here sets out the form to Excel list of all math and trigonometric functions, see the detailed note form. From the table is not difficult to find, Excel provides the basic math and trigonometric functions have been included we would normally be used in a variety of mathematical formula and trigonometric functions. Detailed usage of these functions, I do not go into details here, the following from the application point of view as we demonstrate the use of these methods function. one, with the sum of the functions of the application SUM function is used in the largest number of Excel functions, use it to sum operator can be ignored there is text, data spaces, such as cells, grammar simple and easy to use. We believe this is also the first to learn how to use one of the Excel function. But in fact, Excel provides more than just the sum SUM of a function, but also SUBTOTAL, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2 several functions. I will be here in a payroll unit as an example to highlight the SUM (the calculation of a set of parameters and), SUMIF (to meet the conditions of the range sum of a) the use of. (Note: In order to seek simple example calculations ignore taxes.)
SUM
1, the row or column sum The most common form of wages (in the above chart) as an example, it is characterized by the need for rows or columns within the sum of a number of cells. For example, for the unit in May 2001 the total amount of the actual payment of wages, you can enter in the H13 formula: = SUM (H3: H12) 2, the regional sum Region commonly used in the summation of a worksheet for all the data in the aggregate. At this point you can let the cell pointer on the results in the storage cell, and then edit the column in the Excel input formula "= SUM ()", with the middle mouse click in the brackets, and finally dragged off the need to sum all cells. If these cells are not continuous, you can hold down the Ctrl key, respectively, of their trailers. The cells need less, you can hold down the Ctrl key to select them one by one, and then by hand in the formula quoted in the former cell together with the negative sign. Of course, you can also use the formula option board to complete the work, but for the SUM function is to hand or faster. For example, H13 can also be written in the formula: = SUM (D3: D12, F3: F12)-SUM (G3: G12) 3, attention SUM function parameters, was the sum or range of cells can not be more than 30. In other words, SUM function appears in parenthesis separator (comma) is not more than 29, otherwise Excel would prompt too many parameters. Summation of the need to participate in a constant, can be used "= SUM (range, constant)" the form of direct reference, general reference is absolutely no need to place the cell constants. SUMIF SUMIF function can meet the conditions of a range sum, the conditions can be numerical, text or expression, can be applied to personnel, salaries and performance statistics. Still above the map as an example, the needs of the wage table were calculated in all sections of the wage distribution. To calculate the sales department in May 2001 overtime situation. Species in the F15 enter the formula for the = SUMIF ($ C $ 3: $ C $ 12, "Sales", $ F $ 3: $ F $ 12) Which "$ C $ 3: $ C $ 12" for the provision of logic to determine the basis of the range, "sales department" to assess the condition of statistical only $ C $ 3: $ C $ 12 area departments to "Sales" in the cell, $ F $ 3: $ F $ 12 for the actual sum of the range. |
